package com.itheima.dao;

import com.itheima.domain.Assessment;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface PsychologyDao {

    @Select("select * from t_assessment")
        //心理测评查询
    List<Assessment> PsychologyFindAll();

    //根据姓名/档案号查询
    @Select("select code,name,date,peaceful,gasempty,bodyempty,yinempty,phlegm,dampheat,blood,depressed,special from t_assessment where code= #{code} or name=#{name}")
    List<Assessment> PsychologyConditionFindAll();


    @Delete("delete from t_assessment where id=#{id}")
    //删除
    void deletePsychology(Assessment assessment);
}
